Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, City, Classification
Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
212468 | 212468 | 24.90.1966 | 0 | 1 | 339862 | Drawings and Prints 11 | Book 97 | The Gallery of Illustrious Americans, Containing the Portraits and Biographical Sketches of Twenty-four of the Most Eminent Citizens of the American Republic | Lithographer|Artist|Publisher 1007 | After | Francis d' Avignon|Mathew B. Brady|Brady, D'Avignon and Company | French, 1813–1861, active America 1840–60|American, born Ireland, 1823?–1896 New York|New York, NY | Avignon, Francis d'|Brady, Mathew B.|Brady, D'Avignon and Company 19580 | French|American|American 952 | 1813 |1823 |1800 | 1861 |1896 |1900 | 1850 | 1850 | 1850 | Illustrations: lithographs after daguerrotypes 32170 | 21 3/4 x 15 1/2 x 3/4 in. (55.2 x 39.4 x 1.9 cm) | Bequest of Charles Allen Munn, 1924 | Books 442 | http://www.metmuseum.org/art/collection/search/339862 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
219254 | 219254 | 1972.682.1 | 0 | 0 | 346772 | Drawings and Prints 11 | Book 97 | 21 Delightful Ways of Committing Suicide | Illustrator|Publisher|Author 1215 | Preface by | Jean Bruller|Covici, Friede, Inc.|Corey Ford | New York, NY|American, 1902–1969 | Bruller, Jean|Covici, Friede, Inc.|Ford, Corey 22419 | French|American|American 952 | 1900 |1902 | 1999 |1969 | 1930 | 1930 | 1930 | Illustrations: photoreproductions of original drawings 33371 | 9 7/16 x 6 5/16 in. (24 x 16 cm) | Gift of A. Hyatt Mayor, 1972 | New York 3 | Books 442 | http://www.metmuseum.org/art/collection/search/346772 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
221083 | 221083 | 1971.575 | 0 | 0 | 348624 | Drawings and Prints 11 | Book 97 | Old French Fairy Tales | Author|Illustrator|Publisher 1154 | Comtesse de Segur|Virginia Frances Sterrett|Penn Publishing Co. | French, Russia 1799–1874 Paris|American, Chicago, Illinois 1900–1931 Los Angeles, California|Philadelphia, Pennsylvania | Segur, Comtesse de|Sterrett, Virginia Frances|Penn Publishing Co. 23707 | French|American|American 952 | 1799 |1900 |1900 | 1874 |1931 |1950 | 1920 | 1920 | 1920 | Illustrations: photomechanical reproductions of original drawings 34075 | 11 1/4 x 9 1/16 in. (28.5 x 23 cm) | Gift of Mrs. Sylvan C. Coleman, 1971 | Philadelphia 1 | Books 442 | http://www.metmuseum.org/art/collection/search/348624 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
221829 | 221829 | 66.656.3 | 0 | 0 | 349388 | Drawings and Prints 11 | Book 97 | The Graveyard by the Sea | Author|Publisher|Illustrator 1466 | Illustrated and translated by | Paul Valéry|Centaur Press|Emlen Etting | French, Sète 1871–1945 Paris|American, Philadelphia, Pennsylvania|American, Philadelphia, Pensylvannia 1905–1993 | Valéry, Paul|Centaur Press|Etting, Emlen Pope 24203 | French|American|American 952 | 1871 |1900 |1905 | 1945 |1950 |1993 | 1932 | 1932 | 1932 | Illustrations: photoreproductions of original drawings 33371 | 10 1/4 x 8 1/16 in. (26 x 20.5 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966 | Philadelphia 1 | Books 442 | http://www.metmuseum.org/art/collection/search/349388 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
221909 | 221909 | 66.757.4 | 0 | 0 | 349469 | Drawings and Prints 11 | Book 97 | Selected Fables | Author|Illustrator|Publisher 1154 | Jean de La Fontaine|Alexander Calder|Quadrangle Press | French, Château-Thierry 1621–1695 Paris|American, Philadelphia, Pennsylvania 1898–1976 New York|American, New York | La Fontaine, Jean de|Calder, Alexander|Quadrangle Press 24252 | French|American|American 952 | 1621 |1898 |1900 | 1695 |1976 |1999 | 1948 | 1948 | 1948 | Illustrations: photoreproductions of original drawings 33371 | 12 3/8 x 9 7/16 in. (31.5 x 24 cm) | Purchase, John B. Turner Fund, 1966 | New York 3 | Books 442 | http://www.metmuseum.org/art/collection/search/349469 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
226604 | 226604 | 1973.554 | 0 | 0 | 354217 | Drawings and Prints 11 | Book 97 | Le Voyage | Author|Illustrator|Publisher 1154 | Silhouettes by | Paul Morand|Ugo Mochi|Heron Press | French, Paris 1888–1976|American, Florence, Italy 1889–1977|American, New York | Morand, Paul|Mochi, Ugo|Heron Press 27813 | French|American|American 952 | 1888 |1889 | 1976 |1977 | 1930 | 1930 | 1930 | Illustrations: silhouettes 35671 | 9 13/16 x 6 1/2 in. (25 x 16.5 cm) | Mary Martin Fund, 1973 | Books 442 | http://www.metmuseum.org/art/collection/search/354217 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
227638 | 227638 | 1991.1029.2 | 0 | 0 | 355258 | Drawings and Prints 11 | Book 97 | Puss in Boots | Author|Illustrator|Publisher 1154 | Charles Perrault|Fred Marcellino|Farrar, Straus and Giroux | French, Paris 1628–1703 Paris|American, Brooklyn, New York 1939–2001|New York, NY | and Michael Di Capua Books, New York | Perrault, Charles|Marcellino, Fred|Farrar, Straus and Giroux 28520 | French|American|American 952 | 1628 |1939 |1900 | 1703 |2001 |2050 | 1990 | 1990 | 1990 | Illustrations: photomechanical reproductions of original drawings 34075 | 11 1/4 x 8 7/8 in. (28.5 x 22.5 cm) | Gift of David Kiehl, in honor of Julie Anne Kiehl, l991 | Books 442 | http://www.metmuseum.org/art/collection/search/355258 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
231946 | 231946 | 1970.565.585 | 0 | 0 | 359691 | Drawings and Prints 11 | Book 97 | The Condemned to Death; Le Condamné à Mort | Author|Translator|Translator|Translator|Translator 3705 | Written by|Translated by|Translated by|Translated by|Translated and illustrated by | Jean Genet|Diane di Prima|Alan Marlowe|Harriet Rohmer|Bret Rohmer | French, Paris 1910–1986 Paris|American, born Brooklyn, New York 1934|American, 20th century|20th century|20th century | Genet, Jean|di Prima, Diane|Marlowe, Alan|Rohmer, Harriet|Rohmer, Bret 31106 | French|American|American 952 | 1910 |1934 |1900 |1900 |1900 | 1986 |1934 |1999 |1999 |1999 | ca. 1965 | 1960 | 1970 | Overall: 8 3/4 x 5 7/8 x 1/8 in. (22.2 x 14.9 x 0.3 cm) | Gift of Lincoln Kirstein, 1970 | Books 442 | http://www.metmuseum.org/art/collection/search/359691 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
238130 | 238130 | 1988.1095(29) | 0 | 0 | 366162 | Drawings and Prints 11 | Print 731 | Untitled | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Judith Murray | American, born New York 1941 | Atelier Franck Bordas|American Abstract Artists|Murray, Judith 32743 | French|American|American 952 | 1936 |1941 | 9999 |2041 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 12 3/4 x 9 13/16 in. (32.4 x 24.9 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366162 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238132 | 238132 | 1988.1095(31) | 0 | 0 | 366164 | Drawings and Prints 11 | Print 731 | Detail | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Henry Pearson | American, Kinston, North Carolina 1914–2006 New York | Atelier Franck Bordas|American Abstract Artists|Pearson, Henry 32745 | French|American|American 952 | 1936 |1914 | 9999 |2006 | 1987 | 1987 | 1987 | Lithograph 14948 | Sheet: 12 13/16 × 9 13/16 in. (32.5 × 25 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366164 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238133 | 238133 | 1988.1095(32) | 0 | 0 | 366165 | Drawings and Prints 11 | Print 731 | Two Codes | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Lucio Pozzi | American, born 1935 | Atelier Franck Bordas|American Abstract Artists|Pozzi, Lucio 32746 | French|American|American 952 | 1936 |1935 | 9999 |2035 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 12 3/4 x 9 13/16 in. (32.4 x 24.9 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366165 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238134 | 238134 | 1988.1095(33) | 0 | 0 | 366166 | Drawings and Prints 11 | Print 731 | Tower Fantasy | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Joan Webster Price | American, born 1931 | Atelier Franck Bordas|American Abstract Artists|Price, Joan Webster 32747 | French|American|American 952 | 1936 |1931 | 9999 |2031 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 12 3/4 x 9 13/16 in. (32.4 x 24.9 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366166 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238135 | 238135 | 1988.1095(34) | 0 | 0 | 366167 | Drawings and Prints 11 | Print 731 | P/C | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Raquel Rabinovich | American, born Buenos Aires 1929 | Atelier Franck Bordas|American Abstract Artists|Rabinovich, Raquel 32748 | French|American|American 952 | 1936 |1929 | 9999 |2029 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 12 3/4 x 9 13/16 in. (32.4 x 24.9 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366167 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238136 | 238136 | 1988.1095(35) | 0 | 0 | 366168 | Drawings and Prints 11 | Print 731 | Trellis | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Leo Rabkin | American, born Cincinnati, Ohio 1919 | Atelier Franck Bordas|American Abstract Artists|Rabkin, Leo 32749 | French|American|American 952 | 1936 |1919 | 9999 |2019 | 1987 | 1987 | 1987 | Lithograph 14948 | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366168 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
238137 | 238137 | 1988.1095(36) | 0 | 0 | 366169 | Drawings and Prints 11 | Print 731 | Point-to-Point | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Ce (Cecilia) Roser | American, born 1930 | Atelier Franck Bordas|American Abstract Artists|Roser, Ce (Cecilia) 32750 | French|American|American 952 | 1936 |1930 | 9999 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 12 3/4 x 9 13/16 in. (32.4 x 24.9 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366169 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238138 | 238138 | 1988.1095(37) | 0 | 0 | 366170 | Drawings and Prints 11 | Print 731 | Interweaving Rhythms | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Irene Victoria Rousseau | American, born 1941 | Atelier Franck Bordas|American Abstract Artists|Rousseau, Irene Victoria 32751 | French|American|American 952 | 1936 |1941 | 9999 |2041 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 9 13/16 x 12 3/4 in. (24.9 x 32.4 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366170 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238139 | 238139 | 1988.1095(38) | 0 | 0 | 366171 | Drawings and Prints 11 | Print 731 | Philadelphia | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|James L. Seawright Jr. | American, born 1922 | Atelier Franck Bordas|American Abstract Artists|Seawright, James L. Jr. 32752 | French|American|American 952 | 1936 |1922 | 9999 |2022 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 9 13/16 x 12 3/4 in. (24.9 x 32.4 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366171 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238140 | 238140 | 1988.1095(39) | 0 | 0 | 366172 | Drawings and Prints 11 | Print 731 | Crucible | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Louis Silverstein | American, active 1980s | Atelier Franck Bordas|American Abstract Artists|Silverstein, Louis 32753 | French|American|American 952 | 1936 |1950 | 9999 |2000 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 12 3/4 x 9 13/16 in. (32.4 x 24.9 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366172 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238142 | 238142 | 1988.1095(41) | 0 | 0 | 366174 | Drawings and Prints 11 | Print 731 | "Dead Dog on a Beach" series | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Helen Soreff | American, New York 1926–1998 New York | Atelier Franck Bordas|American Abstract Artists|Soreff, Helen 32755 | French|American|American 952 | 1936 |1934 | 9999 |2034 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 9 13/16 x 12 3/4 in. (24.9 x 32.4 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366174 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238143 | 238143 | 1988.1095(43) | 0 | 0 | 366175 | Drawings and Prints 11 | Print 731 | AARKA | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Merrill Wagner | American, born 1935 | Atelier Franck Bordas|American Abstract Artists|Wagner, Merrill 32756 | French|American|American 952 | 1936 |1935 | 9999 |2035 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 9 13/16 x 12 3/4 in. (24.9 x 32.4 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366175 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
238144 | 238144 | 1988.1095(44) | 0 | 0 | 366176 | Drawings and Prints 11 | Print 731 | Square | From American Abstract Artists 50th Anniversary Print Portfolio 785 | Printer|Publisher|Artist 1066 | Atelier Franck Bordas, Paris|American Abstract Artists|Mac Wells | American, born Cleveland, Ohio, 1925 | Atelier Franck Bordas|American Abstract Artists|Wells, Mac 32757 | French|American|American 952 | 1936 |1925 | 9999 |2025 | 1987 | 1987 | 1987 | Lithograph 14948 | sheet: 12 3/4 x 9 13/16 in. (32.4 x 24.9 cm) | Gift of American Abstract Artists, 1988 | Prints 13 | http://www.metmuseum.org/art/collection/search/366176 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
265078 | 265078 | Ref.45376 | 0 | 0 | 394045 | Drawings and Prints 11 | Book 97 | A Treatise on Etching. Text and Plates by Maxime Lalanne. Authorized Edition, translated from the second French edition by S.R. Koehler. With an introductory chapter and notes by the translator. | Author|Translator|Publisher 1201 | Written and illustrated by | Maxime-François-Antoine Lalanne|Sylvester Rosa Koehler|Estes and Lauriat | French, Bordeaux 1827–1886 Nogent-sur-Marne|American (born Germany) Leipzig 1837–1900 Littleton, New Hampshire|Boston, Massachusetts | Lalanne, Maxime-François-Antoine|Koehler, Sylvester Rosa|Estes and Lauriat 38771 | French|American|American 952 | 1827 |1870 |1850 | 1886 |1920 |1900 | 1880 | 1880 | 1880 | Illustrations: etching, and photomechanical process? 42594 | 10 3/16 x 7 5/16 x 11/16 in. (25.9 x 18.5 x 1.7 cm) | Gift of Theodore De Witt | Books 442 | http://www.metmuseum.org/art/collection/search/394045 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
270665 | 270665 | 49.55.330(8) | 0 | 0 | 399794 | Drawings and Prints 11 | Print 731 | 291, No. 4, June 1915 | Artist|Artist|Artist 53 | Francis Picabia|John Marin|Agnes Ernst Meyer | French, Paris 1879–1953 Paris|American, Rutherford, New Jersey 1870–1953 Cape Split, Maine|American, 1887–1970 | Picabia, Francis|Marin, John|Meyer, Agnes Ernst 40199 | French|American|American 952 | 1879 |1870 |1887 | 1953 |1953 |1970 | 1915 | 1915 | 1915 | Alfred Stieglitz Collection, 1949 | Prints 13 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/399794 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
342321 | 342321 | 45.135.1a | 0 | 0 | 490998 | Modern and Contemporary Art 4 | Sample 1077 | Piece | American 1 | Manufacturer|Designer|Designer 241 | Bianchini-Férier|Peter Todd Mitchell|Norman Norell | French, founded Lyons, 1888|American, New York 1928–1988 Sitges|American, Noblesville, Indiana 1900–1972 New York | Bianchini-Férier|Mitchell, Peter Todd|Norell, Norman 47157 | French|American|American 952 | 1888 |1928 |1900 | 2088 |1988 |1972 | 1944 | 1944 | 1944 | Rayon (Enka), printed 52983 | 31 x 18 in. (78.7 cm. x 45.7 cm. ) | Gift of Bianchini, Ferier, Inc., 1945 | Textiles-Printed 239 | http://www.metmuseum.org/art/collection/search/490998 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
343053 | 343053 | 45.135.1b | 0 | 0 | 491795 | Modern and Contemporary Art 4 | Textile piece 6366 | Textile piece | American 1 | Manufacturer|Designer|Designer 241 | Bianchini-Férier|Peter Todd Mitchell|Norman Norell | French, founded Lyons, 1888|American, New York 1928–1988 Sitges|American, Noblesville, Indiana 1900–1972 New York | Bianchini-Férier|Mitchell, Peter Todd|Norell, Norman 47157 | French|American|American 952 | 1888 |1928 |1900 | 2088 |1988 |1972 | 1944 | 1944 | 1944 | Rayon (Enka), printed 52983 | 10 3/4 × 8 1/8 in. (27.3 × 20.6 cm) | Gift of Bianchini, Ferier Inc., 1945 | Textiles-Printed 239 | http://www.metmuseum.org/art/collection/search/491795 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" ( "Object Number" TEXT, "Is Highlight" INTEGER, "Is Public Domain" INTEGER, "Object ID" INTEGER, "Department" INTEGER, "Object Name" INTEGER, "Title" TEXT, "Culture" INTEGER, "Period" REAL, "Dynasty" INTEGER, "Reign" INTEGER, "Portfolio" INTEGER, "Artist Role" INTEGER, "Artist Prefix" REAL, "Artist Display Name" TEXT, "Artist Display Bio" TEXT, "Artist Suffix" REAL, "Artist Alpha Sort" INTEGER, "Artist Nationality" INTEGER, "Artist Begin Date" TEXT, "Artist End Date" TEXT, "Object Date" TEXT, "Object Begin Date" INTEGER, "Object End Date" INTEGER, "Medium" INTEGER, "Dimensions" TEXT, "Credit Line" TEXT, "Geography Type" INTEGER, "City" INTEGER, "State" INTEGER, "County" INTEGER, "Country" INTEGER, "Region" INTEGER, "Subregion" INTEGER, "Locale" INTEGER, "Locus" INTEGER, "Excavation" INTEGER, "River" INTEGER, "Classification" INTEGER, "Rights and Reproduction" REAL, "Link Resource" TEXT, "Metadata Date" TEXT, "Repository" INTEGER , FOREIGN KEY ("Department") REFERENCES [Department](id), FOREIGN KEY ("Object Name") REFERENCES [Object Name](id), FOREIGN KEY ("Culture") REFERENCES [Culture](id), FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id), FOREIGN KEY ("Reign") REFERENCES [Reign](id), FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id), FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id), FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id), FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id), FOREIGN KEY ("Medium") REFERENCES [Medium](id), FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id), FOREIGN KEY ("City") REFERENCES [City](id), FOREIGN KEY ("State") REFERENCES [State](id), FOREIGN KEY ("County") REFERENCES [County](id), FOREIGN KEY ("Country") REFERENCES [Country](id), FOREIGN KEY ("Region") REFERENCES [Region](id), FOREIGN KEY ("Subregion") REFERENCES [Subregion](id), FOREIGN KEY ("Locale") REFERENCES [Locale](id), FOREIGN KEY ("Locus") REFERENCES [Locus](id), FOREIGN KEY ("Excavation") REFERENCES [Excavation](id), FOREIGN KEY ("River") REFERENCES [River](id), FOREIGN KEY ("Classification") REFERENCES [Classification](id), FOREIGN KEY ("Repository") REFERENCES [Repository](id)); CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department"); CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name"); CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture"); CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty"); CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign"); CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio"); CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role"); CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort"); CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality"); CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium"); CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type"); CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City"); CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State"); CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County"); CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country"); CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region"); CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion"); CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale"); CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus"); CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation"); CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River"); CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification"); CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository"); CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight"); CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain"); CREATE INDEX metobjects_Department ON MetObjects("Department"); CREATE INDEX metobjects_Culture ON MetObjects("Culture"); CREATE INDEX metobjects_Period ON MetObjects("Period"); CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty"); CREATE INDEX metobjects_Medium ON MetObjects("Medium"); CREATE INDEX metobjects_City ON MetObjects("City"); CREATE INDEX metobjects_State ON MetObjects("State"); CREATE INDEX metobjects_County ON MetObjects("County"); CREATE INDEX metobjects_Country ON MetObjects("Country"); CREATE INDEX metobjects_Region ON MetObjects("Region"); CREATE INDEX metobjects_Subregion ON MetObjects("Subregion"); CREATE INDEX metobjects_Locale ON MetObjects("Locale"); CREATE INDEX metobjects_Locus ON MetObjects("Locus"); CREATE INDEX metobjects_Excavation ON MetObjects("Excavation"); CREATE INDEX metobjects_River ON MetObjects("River");